/*
 Navicat Premium Data Transfer

 Source Server         : 本人mysql
 Source Server Type    : MySQL
 Source Server Version : 80200 (8.2.0)
 Source Host           : localhost:3306
 Source Schema         : ry-vue

 Target Server Type    : MySQL
 Target Server Version : 80200 (8.2.0)
 File Encoding         : 65001

 Date: 22/03/2024 09:18:36
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for flow_definition
-- ----------------------------
DROP TABLE IF EXISTS `flow_definition`;
CREATE TABLE `flow_definition` (
                                   `id` bigint unsigned NOT NULL COMMENT '主键id',
                                   `flow_code` varchar(40)  NOT NULL COMMENT '流程编码',
                                   `flow_name` varchar(100)  NOT NULL COMMENT '流程名称',
                                   `version` varchar(20)  NOT NULL COMMENT '流程版本',
                                   `is_publish` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否发布（0未发布 1已发布 9失效）',
                                   `from_custom` char(1)  DEFAULT 'N' COMMENT '审批表单是否自定义（Y是 N否）',
                                   `from_path` varchar(100)  DEFAULT NULL COMMENT '审批表单路径',
                                   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                   PRIMARY KEY (`id`) USING BTREE,
                                   UNIQUE KEY `flow_code_version` (`flow_code`,`version`) USING BTREE
) ENGINE=InnoDB COMMENT='流程定义表';

-- ----------------------------
-- Records of flow_definition
-- ----------------------------
BEGIN;
INSERT INTO `flow_definition` (`id`, `flow_code`, `flow_name`, `version`, `is_publish`, `from_custom`, `from_path`, `create_time`, `update_time`) VALUES (1164575944237780992, 'leaveFlow-serial1', '串行-简单', '1.0', 1, 'N', 'test/leave/approve', '2023-10-19 14:49:02', '2024-03-18 17:19:07');
INSERT INTO `flow_definition` (`id`, `flow_code`, `flow_name`, `version`, `is_publish`, `from_custom`, `from_path`, `create_time`, `update_time`) VALUES (1164575944237780993, 'leaveFlow-serial2', '串行-通过互斥', '1.0', 1, 'N', 'test/leave/approve', '2023-10-19 14:49:02', '2024-03-18 13:53:14');
INSERT INTO `flow_definition` (`id`, `flow_code`, `flow_name`, `version`, `is_publish`, `from_custom`, `from_path`, `create_time`, `update_time`) VALUES (1164575944237780994, 'leaveFlow-parallel1', '并行-汇聚', '1.0', 1, 'N', 'test/leave/approve', '2023-10-19 14:49:02', '2024-03-18 10:33:51');
INSERT INTO `flow_definition` (`id`, `flow_code`, `flow_name`, `version`, `is_publish`, `from_custom`, `from_path`, `create_time`, `update_time`) VALUES (1164575944237780995, 'leaveFlow-parallel2', '并行-分开', '1.0', 1, 'N', 'test/leave/approve', '2023-10-19 14:49:02', '2024-03-18 10:33:52');
INSERT INTO `flow_definition` (`id`, `flow_code`, `flow_name`, `version`, `is_publish`, `from_custom`, `from_path`, `create_time`, `update_time`) VALUES (1164867267142488064, 'leaveFlow-serial3', '串行-驳回互斥', '1.0', 1, 'N', 'test/leave/approve', '2023-10-20 10:06:39', '2024-03-18 11:47:27');
COMMIT;

-- ----------------------------
-- Table structure for flow_his_task
-- ----------------------------
DROP TABLE IF EXISTS `flow_his_task`;
CREATE TABLE `flow_his_task` (
                                 `id` bigint unsigned NOT NULL COMMENT '主键id',
                                 `definition_id` bigint NOT NULL COMMENT '对应flow_definition表的id',
                                 `instance_id` bigint NOT NULL COMMENT '对应flow_instance表的id',
                                 `tenant_id` varchar(40)  DEFAULT NULL COMMENT '租户id',
                                 `node_code` varchar(100)  DEFAULT NULL COMMENT '开始节点编码',
                                 `node_name` varchar(100)  DEFAULT NULL COMMENT '开始节点名称',
                                 `node_type` tinyint(1) NOT NULL COMMENT '开始节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',
                                 `target_node_code` varchar(100)  DEFAULT NULL COMMENT '目标节点编码',
                                 `target_node_name` varchar(100)  DEFAULT NULL COMMENT '结束节点名称',
                                 `approver` varchar(40)  DEFAULT NULL COMMENT '审批者',
                                 `permission_flag` varchar(200)  DEFAULT NULL COMMENT '权限标识（权限类型:权限标识，可以多个，如role:1,role:2)',
                                 `flow_status` tinyint(1) NOT NULL COMMENT '流程状态（0待提交 1审批中 2 审批通过 8已完成 9已驳回 10失效）',
                                 `gateway_node` varchar(40)  DEFAULT NULL COMMENT '所属并行网关节点编码',
                                 `message` varchar(500)  DEFAULT NULL COMMENT '审批意见',
                                 `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                 `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                 PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB COMMENT='历史任务记录表';

-- ----------------------------
-- Records of flow_his_task
-- ----------------------------
BEGIN;
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1220409808247721984, 1164575944237780992, 1220409808209973248, NULL, '2', '待提交', 1, '3', '组长审批', '1', 'role:1,role:2', 2, NULL, NULL, '2024-03-21 16:32:55', '2024-03-21 16:32:55');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1220409819282935808, 1164575944237780992, 1220409808209973248, NULL, '3', '组长审批', 1, '4', '部门经理审批', '1', 'role:1,role:3', 2, NULL, '1', '2024-03-21 16:34:39', '2024-03-21 16:34:39');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1220409856230559745, 1164575944237780993, 1220409856230559744, NULL, '2', '待提交', 1, '3', '组长审批', '1', 'role:1,role:3', 2, NULL, NULL, '2024-03-21 16:33:06', '2024-03-21 16:33:06');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1220409866334638080, 1164575944237780993, 1220409856230559744, NULL, '3', '组长审批', 1, '7', '董事长审批', '1', 'role:1,role:3', 2, NULL, '1', '2024-03-21 16:34:29', '2024-03-21 16:34:29');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1220409902707642369, 1164575944237780994, 1220409902707642368, NULL, '2', '待提交', 1, '3', '小组长审批', '1', 'role:1,role:3', 2, NULL, NULL, '2024-03-21 16:33:17', '2024-03-21 16:33:17');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1220409911679258624, 1164575944237780994, 1220409902707642368, NULL, '3', '小组长审批', 1, '5,7', '大组长审批,hr审批', '1', 'role:1,role:3', 2, NULL, '1', '2024-03-21 16:34:14', '2024-03-21 16:34:14');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1220409942981349377, 1164575944237780995, 1220409942981349376, NULL, '2', '待提交', 1, '3', '小组长审批', '1', 'role:1,role:3', 2, NULL, NULL, '2024-03-21 16:33:27', '2024-03-21 16:33:27');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1220409952586305536, 1164575944237780995, 1220409942981349376, NULL, '3', '小组长审批', 1, '5,7', '大组长审批,董事长审批', '1', 'role:1,role:3', 2, NULL, 'undefined', '2024-03-21 16:34:04', '2024-03-21 16:34:04');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1220409986782466048, 1164867267142488064, 1220409986778271744, NULL, '2', '中间节点1', 1, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', '中间节点2', '1', 'role:1', 2, NULL, NULL, '2024-03-21 16:33:37', '2024-03-21 16:33:37');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1220409996760715264, 1164867267142488064, 1220409986778271744, NULL, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', '中间节点2', 1, '80e10f4c-452c-4a79-b608-84e75831a437', '中间节点3', '1', 'role:1', 2, NULL, 'undefined', '2024-03-21 16:33:51', '2024-03-21 16:33:51');
COMMIT;

-- ----------------------------
-- Table structure for flow_instance
-- ----------------------------
DROP TABLE IF EXISTS `flow_instance`;
CREATE TABLE `flow_instance` (
                                 `id` bigint NOT NULL COMMENT '主键id',
                                 `definition_id` bigint NOT NULL COMMENT '对应flow_definition表的id',
                                 `business_id` varchar(40)  NOT NULL COMMENT '业务id',
                                 `tenant_id` varchar(40)   DEFAULT NULL COMMENT '租户id',
                                 `node_type` tinyint(1) NOT NULL COMMENT '结点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',
                                 `node_code` varchar(40)  NOT NULL COMMENT '流程节点编码',
                                 `node_name` varchar(100)  DEFAULT NULL COMMENT '流程节点名称',
                                 `variable` text  COMMENT '任务变量',
                                 `flow_status` tinyint(1) NOT NULL COMMENT '流程状态（0待提交 1审批中 2 审批通过 8已完成 9已驳回 10失效）',
                                 `create_by` varchar(64)  DEFAULT '' COMMENT '创建者',
                                 `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                 `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                 `ext` varchar(500)  DEFAULT NULL COMMENT '扩展字段',
                                 PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB COMMENT='流程实例表';

-- ----------------------------
-- Records of flow_instance
-- ----------------------------
BEGIN;
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `tenant_id`, `node_type`, `node_code`, `node_name`, `variable`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1220409808209973248, 1164575944237780992, '1220409808033812480', NULL, 1, '4', '部门经理审批', '{\"@type\":\"java.util.HashMap\",\"testLeave\":{\"@type\":\"com.ruoyi.system.domain.TestLeave\",\"id\":\"1220409808033812480\",\"type\":0,\"reason\":\"1\",\"startTime\":1710950400000,\"endTime\":1710950400000,\"day\":1,\"instanceId\":1220409808209973248,\"nodeCode\":\"3\",\"nodeName\":\"\\u7EC4\\u957F\\u5BA1\\u6279\",\"flowStatus\":1,\"delFlag\":\"0\",\"createBy\":\"\",\"createTime\":1711009972000,\"updateBy\":\"\",\"updateTime\":1711009975000}}', 1, '1', '2024-03-21 16:32:52', '2024-03-21 16:34:39', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `tenant_id`, `node_type`, `node_code`, `node_name`, `variable`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1220409856230559744, 1164575944237780993, '1220409856108924928', NULL, 1, '7', '董事长审批', '{\"@type\":\"java.util.HashMap\",\"testLeave\":{\"@type\":\"com.ruoyi.system.domain.TestLeave\",\"id\":\"1220409856108924928\",\"type\":1,\"reason\":\"1\",\"startTime\":1710950400000,\"endTime\":1710950400000,\"day\":5,\"instanceId\":1220409856230559744,\"nodeCode\":\"3\",\"nodeName\":\"\\u7EC4\\u957F\\u5BA1\\u6279\",\"flowStatus\":1,\"delFlag\":\"0\",\"createBy\":\"\",\"createTime\":1711009984000,\"updateBy\":\"\",\"updateTime\":1711009986000}}', 1, '1', '2024-03-21 16:33:04', '2024-03-21 16:34:29', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `tenant_id`, `node_type`, `node_code`, `node_name`, `variable`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1220409902707642368, 1164575944237780994, '1220409902627950592', NULL, 1, '7', 'hr审批', '{\"@type\":\"java.util.HashMap\",\"testLeave\":{\"@type\":\"com.ruoyi.system.domain.TestLeave\",\"id\":\"1220409902627950592\",\"type\":2,\"reason\":\"1\",\"startTime\":1710950400000,\"endTime\":1710950400000,\"day\":3,\"instanceId\":1220409902707642368,\"nodeCode\":\"3\",\"nodeName\":\"\\u5C0F\\u7EC4\\u957F\\u5BA1\\u6279\",\"flowStatus\":1,\"delFlag\":\"0\",\"createBy\":\"\",\"createTime\":1711009995000,\"updateBy\":\"\",\"updateTime\":1711009997000}}', 1, '1', '2024-03-21 16:33:15', '2024-03-21 16:34:14', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `tenant_id`, `node_type`, `node_code`, `node_name`, `variable`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1220409942981349376, 1164575944237780995, '1220409942905851904', NULL, 1, '7', '董事长审批', '{\"@type\":\"java.util.HashMap\",\"testLeave\":{\"@type\":\"com.ruoyi.system.domain.TestLeave\",\"id\":\"1220409942905851904\",\"type\":3,\"reason\":\"1\",\"startTime\":1710950400000,\"endTime\":1710950400000,\"day\":1,\"instanceId\":1220409942981349376,\"nodeCode\":\"3\",\"nodeName\":\"\\u5C0F\\u7EC4\\u957F\\u5BA1\\u6279\",\"flowStatus\":1,\"delFlag\":\"0\",\"createBy\":\"\",\"createTime\":1711010005000,\"updateBy\":\"\",\"updateTime\":1711010007000}}', 1, '1', '2024-03-21 16:33:25', '2024-03-21 16:34:04', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `tenant_id`, `node_type`, `node_code`, `node_name`, `variable`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1220409986778271744, 1164867267142488064, '1220409986694385664', NULL, 1, '80e10f4c-452c-4a79-b608-84e75831a437', '中间节点3', '{\"@type\":\"java.util.HashMap\",\"testLeave\":{\"@type\":\"com.ruoyi.system.domain.TestLeave\",\"id\":\"1220409986694385664\",\"type\":4,\"reason\":\"1\",\"startTime\":1710950400000,\"endTime\":1710950400000,\"day\":1,\"instanceId\":1220409986778271744,\"nodeCode\":\"0fbb9fbe-e4bd-4280-94f4-a8f939b760e2\",\"nodeName\":\"\\u4E2D\\u95F4\\u8282\\u70B92\",\"flowStatus\":1,\"delFlag\":\"0\",\"createBy\":\"\",\"createTime\":1711010015000,\"updateBy\":\"\",\"updateTime\":1711010017000}}', 1, '1', '2024-03-21 16:33:35', '2024-03-21 16:33:51', NULL);
COMMIT;

-- ----------------------------
-- Table structure for flow_node
-- ----------------------------
DROP TABLE IF EXISTS `flow_node`;
CREATE TABLE `flow_node` (
                             `id` bigint unsigned NOT NULL COMMENT '主键id',
                             `node_type` tinyint(1) NOT NULL COMMENT '节点类型（0开始节点 1中间节点 2结束结点 3互斥网关 4并行网关）',
                             `definition_id` bigint NOT NULL COMMENT '流程定义id',
                             `node_code` varchar(100)  NOT NULL COMMENT '流程节点编码',
                             `node_name` varchar(100)  DEFAULT NULL COMMENT '流程节点名称',
                             `permission_flag` varchar(200)  DEFAULT NULL COMMENT '权限标识（权限类型:权限标识，可以多个，如role:1,role:2)',
                             `coordinate` varchar(100)  DEFAULT NULL COMMENT '坐标',
                             `skip_any_node` varchar(100)  DEFAULT 'N' COMMENT '是否可以退回任意节点（Y是 N否）',
                             `listener_type` varchar(40)   DEFAULT NULL COMMENT '监听器类型',
                             `listener_path` varchar(200)   DEFAULT NULL COMMENT '监听器路径',
                             `version` varchar(20)  NOT NULL COMMENT '版本',
                             `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                             `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                             PRIMARY KEY (`id`) USING BTREE,
                             UNIQUE KEY `info_id_code` (`definition_id`,`node_code`) USING BTREE COMMENT '保证一个流程中node_code是唯一的'
) ENGINE=InnoDB COMMENT='流程结点表';

-- ----------------------------
-- Records of flow_node
-- ----------------------------
BEGIN;
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391860049776641, 0, 1164575944237780994, '1', '开始', NULL, '140,180|140,180', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391860049776643, 1, 1164575944237780994, '2', '待提交', 'role:1,role:3', '280,180|280,180', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391860049776645, 1, 1164575944237780994, '3', '小组长审批', 'role:1,role:3', '480,180|480,180', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391860049776647, 4, 1164575944237780994, 'f06c0d62-3983-4503-ad1f-f581a89727e6', NULL, NULL, '640,180', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391860049776650, 1, 1164575944237780994, '5', '大组长审批', 'role:1,role:3', '880,140|880,140', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391860049776652, 1, 1164575944237780994, '6', '部门经理审批', 'role:1,role:3', '1100,140|1100,140', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391860049776654, 4, 1164575944237780994, 'd7de884d-e86f-4483-be14-b4350d93a079', NULL, NULL, '1100,300', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391860049776656, 1, 1164575944237780994, '43563e5c-42fb-4f46-936d-70f8727943bf', '董事长审批', 'role:1,role:3', '1100,440|1100,440', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391860049776658, 2, 1164575944237780994, 'd34fb004-0bf5-4ad7-8e05-82200e6f9e78', '结束', NULL, '1100,600|1100,600', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391860049776659, 1, 1164575944237780994, '7', 'hr审批', 'role:1,role:3', '880,300|880,300', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391879658147841, 0, 1164575944237780995, '1', '开始', NULL, '140,220|140,220', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391879658147843, 1, 1164575944237780995, '2', '待提交', 'role:1,role:3', '300,220|300,220', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391879658147845, 1, 1164575944237780995, '3', '小组长审批', 'role:1,role:3', '500,220|500,220', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391879658147847, 4, 1164575944237780995, 'e8d342f3-1353-415f-af62-c02f33a083bd', NULL, NULL, '660,220', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391879658147850, 1, 1164575944237780995, '5', '大组长审批', 'role:1,role:3', '820,120|820,120', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391879658147852, 1, 1164575944237780995, '6', '部门经理审批', 'role:1,role:3', '1040,120|1040,120', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391879662342145, 2, 1164575944237780995, '8', '结束1', NULL, '1240,120|1240,120', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391879662342146, 1, 1164575944237780995, '7', '董事长审批', 'role:1,role:3', '820,280|820,280', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1189391879662342149, 2, 1164575944237780995, '9', '结束2', NULL, '1240,280|1240,280', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219230952664993793, 0, 1164575944237780993, '1', '开始', NULL, '140,300|140,300', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219230952664993795, 1, 1164575944237780993, '2', '待提交', 'role:1,role:3', '300,300|300,300', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219230952664993797, 1, 1164575944237780993, '3', '组长审批', 'role:1,role:3', '500,300|500,300', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219230952664993799, 3, 1164575944237780993, '50a177f6-d9a7-44e8-96d6-afc6d1362192', NULL, NULL, '660,300', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219230952664993802, 1, 1164575944237780993, '4', '大组长审批', 'role:1,role:3', '840,180|840,180', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219230952664993804, 1, 1164575944237780993, '6', '部门经理审批', 'role:1,role:3', '1040,180|1040,180', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219230952664993807, 2, 1164575944237780993, '8', '结束', NULL, '1200,300|1200,300', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219230952664993808, 1, 1164575944237780993, '7', '董事长审批', 'role:1,role:3', '840,420|840,420', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219250805350207489, 0, 1164867267142488064, 'f6c8ca02-6440-4f49-a35f-dfe689e38263', '开始', NULL, '160,200|160,200', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 11:47:25', '2024-03-18 11:47:25');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219250805354401792, 1, 1164867267142488064, '2', '中间节点1', 'role:1', '380,200|380,200', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 11:47:25', '2024-03-18 11:47:25');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219250805354401794, 1, 1164867267142488064, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', '中间节点2', 'role:1', '600,200|600,200', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 11:47:25', '2024-03-18 11:47:25');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219250805354401796, 1, 1164867267142488064, '80e10f4c-452c-4a79-b608-84e75831a437', '中间节点3', 'role:1', '840,200|840,200', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 11:47:25', '2024-03-18 11:47:25');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219250805354401799, 2, 1164867267142488064, '3893b8ab-355a-483f-ac34-e781f1f5d4ca', '结束', NULL, '1060,200|1060,200', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 11:47:25', '2024-03-18 11:47:25');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219250805354401800, 3, 1164867267142488064, 'f038c246-b219-4316-89b9-991ba067c740', NULL, NULL, '700,80', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 11:47:25', '2024-03-18 11:47:25');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219334272574427137, 0, 1164575944237780992, '1', '开始', NULL, '120,280|120,280', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 17:19:05', '2024-03-18 17:19:05');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219334272574427139, 1, 1164575944237780992, '2', '待提交', 'role:1,role:2', '280,280|280,280', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 17:19:05', '2024-03-18 17:19:05');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219334272574427141, 1, 1164575944237780992, '3', '组长审批', 'role:1,role:3', '480,280|480,280', 'Y', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 17:19:05', '2024-03-18 17:19:05');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219334272574427143, 1, 1164575944237780992, '4', '部门经理审批', 'role:1,role:3', '700,280|700,280', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 17:19:05', '2024-03-18 17:19:05');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219334272574427146, 1, 1164575944237780992, '9edc9b26-cab4-4fd4-9a30-c89f11626911', 'hr审批', 'role:1,role:3', '920,280|920,280', 'Y', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 17:19:05', '2024-03-18 17:19:05');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `listener_type`, `listener_path`, `version`, `create_time`, `update_time`) VALUES (1219334272574427148, 2, 1164575944237780992, 'fa0fe17b-66d2-458d-b420-fec5cb14f73d', '结束', NULL, '1120,280|1120,280', 'N', 'start,assignment,finish', 'com.ruoyi.system.Listener.StartListener,323,com.ruoyi.system.Listener.FinishListener', '1.0', '2024-03-18 17:19:05', '2024-03-18 17:19:05');
COMMIT;

-- ----------------------------
-- Table structure for flow_skip
-- ----------------------------
DROP TABLE IF EXISTS `flow_skip`;
CREATE TABLE `flow_skip` (
                             `id` bigint unsigned NOT NULL COMMENT '主键id',
                             `definition_id` bigint NOT NULL COMMENT '流程定义id',
                             `node_id` bigint NOT NULL COMMENT '当前节点id',
                             `now_node_code` varchar(100)  NOT NULL COMMENT '当前流程节点的编码',
                             `now_node_type` tinyint(1) DEFAULT NULL COMMENT '当前节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',
                             `next_node_code` varchar(100)  NOT NULL COMMENT '下一个流程节点的编码',
                             `next_node_type` tinyint(1) DEFAULT NULL COMMENT '下一个节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',
                             `skip_name` varchar(100)  DEFAULT NULL COMMENT '跳转名称',
                             `skip_type` varchar(40)  DEFAULT NULL COMMENT '跳转类型（PASS审批通过 REJECT驳回）',
                             `skip_condition` varchar(200)  DEFAULT NULL COMMENT '跳转条件',
                             `coordinate` varchar(100)  DEFAULT NULL COMMENT '坐标',
                             `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                             `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                             PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB COMMENT='结点跳转关联表';

-- ----------------------------
-- Records of flow_skip
-- ----------------------------
BEGIN;
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776642, 1164575944237780994, 1189391860049776641, '1', 0, '2', 1, NULL, 'PASS', NULL, '160,180;230,180', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776644, 1164575944237780994, 1189391860049776643, '2', 1, '3', 1, NULL, 'PASS', NULL, '330,180;430,180', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776646, 1164575944237780994, 1189391860049776645, '3', 1, 'f06c0d62-3983-4503-ad1f-f581a89727e6', 4, NULL, 'PASS', NULL, '530,180;615,180', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776648, 1164575944237780994, 1189391860049776647, 'f06c0d62-3983-4503-ad1f-f581a89727e6', 4, '5', 1, NULL, 'PASS', NULL, '665,180;683,180;683,140;830,140', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776649, 1164575944237780994, 1189391860049776647, 'f06c0d62-3983-4503-ad1f-f581a89727e6', 4, '7', 1, NULL, 'PASS', NULL, '665,180;685,180;685,300;830,300', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776651, 1164575944237780994, 1189391860049776650, '5', 1, '6', 1, NULL, 'PASS', NULL, '930,140;1050,140', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776653, 1164575944237780994, 1189391860049776652, '6', 1, 'd7de884d-e86f-4483-be14-b4350d93a079', 4, NULL, 'PASS', NULL, '1101,180;1101,276', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776655, 1164575944237780994, 1189391860049776654, 'd7de884d-e86f-4483-be14-b4350d93a079', 4, '43563e5c-42fb-4f46-936d-70f8727943bf', 1, NULL, 'PASS', NULL, '1102,323;1102,400', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776657, 1164575944237780994, 1189391860049776656, '43563e5c-42fb-4f46-936d-70f8727943bf', 1, 'd34fb004-0bf5-4ad7-8e05-82200e6f9e78', 2, NULL, 'PASS', NULL, '1100,480;1100,580', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776660, 1164575944237780994, 1189391860049776659, '7', 1, 'd7de884d-e86f-4483-be14-b4350d93a079', 4, NULL, 'PASS', NULL, '930,300;1075,300', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776661, 1164575944237780994, 1189391860049776659, '7', 1, '3', 1, NULL, 'REJECT', NULL, '880,340;880,360;480,360;480,220', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879658147842, 1164575944237780995, 1189391879658147841, '1', 0, '2', 1, NULL, 'PASS', NULL, '160,220;250,220', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879658147844, 1164575944237780995, 1189391879658147843, '2', 1, '3', 1, NULL, 'PASS', NULL, '350,220;450,220', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879658147846, 1164575944237780995, 1189391879658147845, '3', 1, 'e8d342f3-1353-415f-af62-c02f33a083bd', 4, NULL, 'PASS', NULL, '550,220;635,220', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879658147848, 1164575944237780995, 1189391879658147847, 'e8d342f3-1353-415f-af62-c02f33a083bd', 4, '5', 1, NULL, 'PASS', NULL, '685,220;716,220;716,120;770,120', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879658147849, 1164575944237780995, 1189391879658147847, 'e8d342f3-1353-415f-af62-c02f33a083bd', 4, '7', 1, NULL, 'PASS', NULL, '685,220;715,220;715,280;770,280', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879658147851, 1164575944237780995, 1189391879658147850, '5', 1, '6', 1, NULL, 'PASS', NULL, '870,120;990,120', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879662342144, 1164575944237780995, 1189391879658147852, '6', 1, '8', 2, NULL, 'PASS', NULL, '1090,120;1220,120', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879662342147, 1164575944237780995, 1189391879662342146, '7', 1, '9', 2, NULL, 'PASS', NULL, '870,280;1220,280', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879662342148, 1164575944237780995, 1189391879662342146, '7', 1, '3', 1, NULL, 'REJECT', NULL, '820,320;820,350;500,350;500,260', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219230952664993794, 1164575944237780993, 1219230952664993793, '1', 0, '2', 1, NULL, 'PASS', NULL, '160,300;250,300', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219230952664993796, 1164575944237780993, 1219230952664993795, '2', 1, '3', 1, NULL, 'PASS', NULL, '350,300;450,300', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219230952664993798, 1164575944237780993, 1219230952664993797, '3', 1, '50a177f6-d9a7-44e8-96d6-afc6d1362192', 3, NULL, 'PASS', NULL, '550,300;635,300', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219230952664993800, 1164575944237780993, 1219230952664993799, '50a177f6-d9a7-44e8-96d6-afc6d1362192', 3, '4', 1, '请假时间小于等于4天', 'PASS', '@@le@@|flag@@le@@4', '660,275;660,180;790,180|660,225', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219230952664993801, 1164575944237780993, 1219230952664993799, '50a177f6-d9a7-44e8-96d6-afc6d1362192', 3, '7', 1, '请假时间大于4天', 'PASS', '@@gt@@|flag@@gt@@4', '660,325;660,420;790,420|660,375', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219230952664993803, 1164575944237780993, 1219230952664993802, '4', 1, '6', 1, NULL, 'PASS', NULL, '890,180;990,180', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219230952664993805, 1164575944237780993, 1219230952664993804, '6', 1, '8', 2, NULL, 'PASS', NULL, '1090,180;1141,180;1141,300;1180,300', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219230952664993806, 1164575944237780993, 1219230952664993804, '6', 1, '4', 1, NULL, 'REJECT', NULL, '1040,140;1040,120;840,120;840,140', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219230952664993809, 1164575944237780993, 1219230952664993808, '7', 1, '8', 2, NULL, 'PASS', NULL, '890,420;910,420;910,300;1180,300', '2024-03-18 10:28:31', '2024-03-18 10:28:31');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219250805350207490, 1164867267142488064, 1219250805350207489, 'f6c8ca02-6440-4f49-a35f-dfe689e38263', 0, '2', 1, NULL, 'PASS', NULL, '180,200;330,200', '2024-03-18 11:47:25', '2024-03-18 11:47:25');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219250805354401793, 1164867267142488064, 1219250805354401792, '2', 1, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', 1, NULL, 'PASS', NULL, '430,200;550,200', '2024-03-18 11:47:25', '2024-03-18 11:47:25');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219250805354401795, 1164867267142488064, 1219250805354401794, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', 1, '80e10f4c-452c-4a79-b608-84e75831a437', 1, NULL, 'PASS', NULL, '650,200;790,200', '2024-03-18 11:47:25', '2024-03-18 11:47:25');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219250805354401797, 1164867267142488064, 1219250805354401796, '80e10f4c-452c-4a79-b608-84e75831a437', 1, '3893b8ab-355a-483f-ac34-e781f1f5d4ca', 2, NULL, 'PASS', NULL, '890,200;1040,200', '2024-03-18 11:47:25', '2024-03-18 11:47:25');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219250805354401798, 1164867267142488064, 1219250805354401796, '80e10f4c-452c-4a79-b608-84e75831a437', 1, 'f038c246-b219-4316-89b9-991ba067c740', 3, NULL, 'REJECT', NULL, '840,160;840,79;724,79', '2024-03-18 11:47:25', '2024-03-18 11:47:25');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219250805354401801, 1164867267142488064, 1219250805354401800, 'f038c246-b219-4316-89b9-991ba067c740', 3, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', 1, '请假时间大于4天', 'REJECT', '@@gt@@|flag@@gt@@4', '675,80;600,80;600,160|600,80', '2024-03-18 11:47:25', '2024-03-18 11:47:25');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219250805354401802, 1164867267142488064, 1219250805354401800, 'f038c246-b219-4316-89b9-991ba067c740', 3, '2', 1, '请假时间小于等于4天', 'REJECT', '@@le@@|flag@@le@@4', '700,55;700,35;380,35;380,160|540,35', '2024-03-18 11:47:25', '2024-03-18 11:47:25');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219334272574427138, 1164575944237780992, 1219334272574427137, '1', 0, '2', 1, NULL, 'PASS', NULL, '140,280;230,280', '2024-03-18 17:19:05', '2024-03-18 17:19:05');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219334272574427140, 1164575944237780992, 1219334272574427139, '2', 1, '3', 1, NULL, 'PASS', NULL, '330,280;430,280', '2024-03-18 17:19:05', '2024-03-18 17:19:05');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219334272574427142, 1164575944237780992, 1219334272574427141, '3', 1, '4', 1, NULL, 'PASS', NULL, '530,280;650,280', '2024-03-18 17:19:05', '2024-03-18 17:19:05');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219334272574427144, 1164575944237780992, 1219334272574427143, '4', 1, '9edc9b26-cab4-4fd4-9a30-c89f11626911', 1, NULL, 'PASS', NULL, '750,280;870,280', '2024-03-18 17:19:05', '2024-03-18 17:19:05');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219334272574427145, 1164575944237780992, 1219334272574427143, '4', 1, '2', 1, NULL, 'REJECT', NULL, '700,240;700,210;280,210;280,240', '2024-03-18 17:19:05', '2024-03-18 17:19:05');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1219334272574427147, 1164575944237780992, 1219334272574427146, '9edc9b26-cab4-4fd4-9a30-c89f11626911', 1, 'fa0fe17b-66d2-458d-b420-fec5cb14f73d', 2, NULL, 'PASS', NULL, '970,280;1100,280', '2024-03-18 17:19:05', '2024-03-18 17:19:05');
COMMIT;

-- ----------------------------
-- Table structure for flow_task
-- ----------------------------
DROP TABLE IF EXISTS `flow_task`;
CREATE TABLE `flow_task` (
                             `id` bigint NOT NULL COMMENT '主键id',
                             `definition_id` bigint NOT NULL COMMENT '对应flow_definition表的id',
                             `instance_id` bigint NOT NULL COMMENT '对应flow_instance表的id',
                             `tenant_id` varchar(40)  DEFAULT NULL COMMENT '租户id',
                             `node_code` varchar(100)  NOT NULL COMMENT '节点编码',
                             `node_name` varchar(100)  DEFAULT NULL COMMENT '节点名称',
                             `node_type` tinyint(1) NOT NULL COMMENT '节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',
                             `permission_flag` varchar(200)  DEFAULT NULL COMMENT '权限标识（权限类型:权限标识，可以多个，如role:1,role:2)',
                             `flow_status` tinyint(1) NOT NULL COMMENT '流程状态（0待提交 1审批中 2 审批通过 8已完成 9已驳回 10失效）',
                             `approver` varchar(40)  DEFAULT NULL COMMENT '审批者',
                             `assignee` varchar(40)  DEFAULT NULL COMMENT '转办人',
                             `gateway_node` varchar(40)  DEFAULT NULL COMMENT '所属并行网关节点编码',
                             `variable` text   COMMENT '任务变量',
                             `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                             `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                             PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB COMMENT='待办任务表';

-- ----------------------------
-- Records of flow_task
-- ----------------------------
BEGIN;
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `variable`, `create_time`, `update_time`) VALUES (1220410055220924416, 1164867267142488064, 1220409986778271744, NULL, '80e10f4c-452c-4a79-b608-84e75831a437', '中间节点3', 1, 'role:1', 1, '1', NULL, NULL, '{\"@type\":\"java.util.HashMap\",\"startFlow\":false}', '2024-03-21 16:33:51', '2024-03-21 16:33:51');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `variable`, `create_time`, `update_time`) VALUES (1220410106521456640, 1164575944237780995, 1220409942981349376, NULL, '5', '大组长审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '{\"@type\":\"java.util.HashMap\",\"startFlow\":false}', '2024-03-21 16:34:04', '2024-03-21 16:34:04');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `variable`, `create_time`, `update_time`) VALUES (1220410106525650944, 1164575944237780995, 1220409942981349376, NULL, '7', '董事长审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '{\"@type\":\"java.util.HashMap\",\"startFlow\":false}', '2024-03-21 16:34:04', '2024-03-21 16:34:04');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `variable`, `create_time`, `update_time`) VALUES (1220410148699377664, 1164575944237780994, 1220409902707642368, NULL, '5', '大组长审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '{\"@type\":\"java.util.HashMap\",\"startFlow\":false}', '2024-03-21 16:34:14', '2024-03-21 16:34:14');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `variable`, `create_time`, `update_time`) VALUES (1220410148699377665, 1164575944237780994, 1220409902707642368, NULL, '7', 'hr审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '{\"@type\":\"java.util.HashMap\",\"startFlow\":false}', '2024-03-21 16:34:14', '2024-03-21 16:34:14');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `variable`, `create_time`, `update_time`) VALUES (1220410214067605504, 1164575944237780993, 1220409856230559744, NULL, '7', '董事长审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '{\"@type\":\"java.util.HashMap\",\"startFlow\":false}', '2024-03-21 16:34:29', '2024-03-21 16:34:29');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `variable`, `create_time`, `update_time`) VALUES (1220410255452803072, 1164575944237780992, 1220409808209973248, NULL, '4', '部门经理审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '{\"@type\":\"java.util.HashMap\",\"startFlow\":false}', '2024-03-21 16:34:39', '2024-03-21 16:34:39');
COMMIT;

-- ----------------------------
-- Table structure for test_leave
-- ----------------------------
DROP TABLE IF EXISTS `test_leave`;
CREATE TABLE `test_leave` (
                              `id` bigint unsigned NOT NULL COMMENT '主键',
                              `type` tinyint NOT NULL COMMENT '请假类型',
                              `reason` varchar(500)  NOT NULL COMMENT '请假原因',
                              `start_time` datetime NOT NULL COMMENT '开始时间',
                              `end_time` datetime NOT NULL COMMENT '结束时间',
                              `day` tinyint DEFAULT NULL COMMENT '请假天数',
                              `instance_id` bigint DEFAULT NULL COMMENT '流程实例的id',
                              `node_code` varchar(100)  DEFAULT NULL COMMENT '节点编码',
                              `node_name` varchar(100)  DEFAULT NULL COMMENT '流程节点名称',
                              `flow_status` tinyint(1) DEFAULT NULL COMMENT '流程状态（0待提交 1审批中 2 审批通过 8已完成 9已驳回 10失效）',
                              `create_by` varchar(64)  DEFAULT '' COMMENT '创建者',
                              `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                              `update_by` varchar(64)  DEFAULT '' COMMENT '更新者',
                              `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                              `del_flag` char(1)  DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
                              PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='OA 请假申请表';

-- ----------------------------
-- Records of test_leave
-- ----------------------------
BEGIN;
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1220409808033812480, 0, '1', '2024-03-21 00:00:00', '2024-03-21 00:00:00', 1, 1220409808209973248, '4', '部门经理审批', 1, '', '2024-03-21 16:32:52', '', '2024-03-21 16:32:55', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1220409856108924928, 1, '1', '2024-03-21 00:00:00', '2024-03-21 00:00:00', 5, 1220409856230559744, '7', '董事长审批', 1, '', '2024-03-21 16:33:04', '', '2024-03-21 16:33:06', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1220409902627950592, 2, '1', '2024-03-21 00:00:00', '2024-03-21 00:00:00', 3, 1220409902707642368, '7', 'hr审批', 1, '', '2024-03-21 16:33:15', '', '2024-03-21 16:33:17', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1220409942905851904, 3, '1', '2024-03-21 00:00:00', '2024-03-21 00:00:00', 1, 1220409942981349376, '7', '董事长审批', 1, '', '2024-03-21 16:33:25', '', '2024-03-21 16:33:27', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1220409986694385664, 4, '1', '2024-03-21 00:00:00', '2024-03-21 00:00:00', 1, 1220409986778271744, '80e10f4c-452c-4a79-b608-84e75831a437', '中间节点3', 1, '', '2024-03-21 16:33:35', '', '2024-03-21 16:33:37', '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
